/*
 Navicat Premium Data Transfer

 Source Server         : 本机
 Source Server Type    : MySQL
 Source Server Version : 50716 (5.7.16)
 Source Host           : localhost:3306
 Source Schema         : mybatis_plus

 Target Server Type    : MySQL
 Target Server Version : 50716 (5.7.16)
 File Encoding         : 65001

 Date: 18/08/2023 09:26:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_info
-- ----------------------------
DROP TABLE IF EXISTS `app_info`;
CREATE TABLE `app_info` (
  `app_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `app_pwd` varchar(200) DEFAULT NULL,
  `app_secret` varchar(50) DEFAULT NULL,
  `app_name` varchar(20) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT '' COMMENT '备注',
  `create_by` bigint(20) NOT NULL COMMENT '创建者',
  `create_date` datetime NOT NULL COMMENT '创建日期',
  `update_by` bigint(20) NOT NULL COMMENT '更新者',
  `update_date` datetime NOT NULL COMMENT '更新日期',
  `del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标记(0:正常，-1:删除)',
  `notify_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`app_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=603327 DEFAULT CHARSET=utf8 COMMENT='对接渠道信息';

-- ----------------------------
-- Records of app_info
-- ----------------------------
BEGIN;
INSERT INTO `app_info` (`app_id`, `app_pwd`, `app_secret`, `app_name`, `remarks`, `create_by`, `create_date`, `update_by`, `update_date`, `del_flag`, `notify_url`) VALUES (123, '$2a$10$tdhTH4xZY4f8QHueu6oPa.buUTsgjzRc0HC2UHKZwYpnScTUZI3rG', '789', '测试渠道1', '', 1, '2019-07-09 17:14:30', 1, '2019-07-09 17:14:32', 0, NULL);
INSERT INTO `app_info` (`app_id`, `app_pwd`, `app_secret`, `app_name`, `remarks`, `create_by`, `create_date`, `update_by`, `update_date`, `del_flag`, `notify_url`) VALUES (456, '$2a$10$tdhTH4xZY4f8QHueu6oPa.buUTsgjzRc0HC2UHKZwYpnScTUZI3rG', 'V1Uuzs7ZtEHAPxO9', '测试渠道2', '', 1, '2019-07-09 17:14:30', 1, '2019-07-09 17:14:32', 0, NULL);
INSERT INTO `app_info` (`app_id`, `app_pwd`, `app_secret`, `app_name`, `remarks`, `create_by`, `create_date`, `update_by`, `update_date`, `del_flag`, `notify_url`) VALUES (789, '$2a$10$Nc8W9B.Yxr71LRciZDR21.CA2CCoWh.llxTlUaOBL5zhx5v7gHFDm', 'HBbSUweCetfddbo2', '测试渠道3', '', 0, '2020-04-30 11:25:17', 0, '2020-04-30 11:28:22', 0, 'http://127.0.0.1:8080/test/notity');
COMMIT;

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `id` int(11) NOT NULL,
  `area_id` varchar(255) DEFAULT NULL COMMENT '区县id',
  `city_id` varchar(255) DEFAULT NULL COMMENT '城市id',
  `area` varchar(255) DEFAULT NULL COMMENT '区县名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of area
-- ----------------------------
BEGIN;
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (1, '1001', '0101', '经开区');
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (2, '1002', '0101', '二七区');
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (3, '1003', '0101', '高新区');
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (4, '1004', '0101', '管城区');
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (5, '1005', '0103', '余杭区');
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (6, '1006', '0103', '滨江区');
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (7, '1007', '0103', '下城区');
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (8, '1008', '0102', '川汇区');
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (9, '1009', '0102', '淮阳区');
INSERT INTO `area` (`id`, `area_id`, `city_id`, `area`) VALUES (10, '1010', '0104', '镇海区');
COMMIT;

-- ----------------------------
-- Table structure for city
-- ----------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
  `id` int(11) NOT NULL,
  `city_id` varchar(255) DEFAULT NULL COMMENT '城市id',
  `province_id` varchar(255) DEFAULT NULL COMMENT '省份id',
  `city` varchar(255) DEFAULT NULL COMMENT '城市名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of city
-- ----------------------------
BEGIN;
INSERT INTO `city` (`id`, `city_id`, `province_id`, `city`) VALUES (1, '0101', '1', '郑州市');
INSERT INTO `city` (`id`, `city_id`, `province_id`, `city`) VALUES (2, '0102', '1', '周口市');
INSERT INTO `city` (`id`, `city_id`, `province_id`, `city`) VALUES (3, '0103', '2', '杭州市');
INSERT INTO `city` (`id`, `city_id`, `province_id`, `city`) VALUES (4, '0104', '2', '宁波市');
COMMIT;

-- ----------------------------
-- Table structure for db1_person1
-- ----------------------------
DROP TABLE IF EXISTS `db1_person1`;
CREATE TABLE `db1_person1` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  `user_create` int(11) NOT NULL COMMENT '创建用户',
  `user_modified` int(11) NOT NULL COMMENT '修改用户',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '逻辑删除:1正常, 0删除',
  `name` varchar(20) NOT NULL COMMENT '名称',
  `age` int(11) NOT NULL COMMENT '年龄',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='人员表';

-- ----------------------------
-- Records of db1_person1
-- ----------------------------
BEGIN;
INSERT INTO `db1_person1` (`id`, `gmt_create`, `gmt_modified`, `user_create`, `user_modified`, `deleted`, `name`, `age`) VALUES (1, '2022-02-11 16:23:34', '2022-02-11 16:23:37', 11, 11, 0, '11', 11);
COMMIT;

-- ----------------------------
-- Table structure for db2_person2
-- ----------------------------
DROP TABLE IF EXISTS `db2_person2`;
CREATE TABLE `db2_person2` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  `user_create` int(11) NOT NULL COMMENT '创建用户',
  `user_modified` int(11) NOT NULL COMMENT '修改用户',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '逻辑删除:1正常, 0删除',
  `name` varchar(20) NOT NULL COMMENT '名称',
  `age` int(11) NOT NULL COMMENT '年龄',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='人员表';

-- ----------------------------
-- Records of db2_person2
-- ----------------------------
BEGIN;
INSERT INTO `db2_person2` (`id`, `gmt_create`, `gmt_modified`, `user_create`, `user_modified`, `deleted`, `name`, `age`) VALUES (1, '2022-02-11 15:34:17', '2022-02-11 15:34:22', 11, 11, 0, '11', 11);
COMMIT;

-- ----------------------------
-- Table structure for mk_bdc_facebycity
-- ----------------------------
DROP TABLE IF EXISTS `mk_bdc_facebycity`;
CREATE TABLE `mk_bdc_facebycity` (
  `id` varchar(255) NOT NULL,
  `faceinfo` text,
  `city` varchar(20) DEFAULT NULL,
  `face_picture` varchar(255) DEFAULT NULL,
  `option_type` int(11) DEFAULT NULL COMMENT '0为增加操作；1为删除操作',
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of mk_bdc_facebycity
-- ----------------------------
BEGIN;
INSERT INTO `mk_bdc_facebycity` (`id`, `faceinfo`, `city`, `face_picture`, `option_type`, `create_time`) VALUES ('1', 'feirhgherjhghkejrhghkjerhghkjeshgkjsshvkjsdhiufhieugfiaushfisdvsdbvdahigueaghiuahviudhsivuhadiugviudahviasdhviuah', '杭州', NULL, NULL, NULL);
INSERT INTO `mk_bdc_facebycity` (`id`, `faceinfo`, `city`, `face_picture`, `option_type`, `create_time`) VALUES ('150b8691-2d8c-11ec-8754-00e04e36b9d9', 'adsfihaoifhaishfaisudhviausdhvidasuhviaosduhvaisudhvisduhvsduihvaiudhfaishfiasudhviasudhviasuhviadsuhviasudhvisduhasdadgss', '宁波', 'http://localhost:8888/MOKO-IMG/1.png', 0, '2021-10-14 17:09:49');
COMMIT;

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permission_name` varchar(255) DEFAULT NULL,
  `permission_tag` varchar(255) DEFAULT NULL,
  `permission_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of permission
-- ----------------------------
BEGIN;
INSERT INTO `permission` (`id`, `permission_name`, `permission_tag`, `permission_url`) VALUES (1, '查询某人', 'user:selectOne', '/test/test1');
INSERT INTO `permission` (`id`, `permission_name`, `permission_tag`, `permission_url`) VALUES (2, '所有权限', 'sys:*', '/');
COMMIT;

-- ----------------------------
-- Table structure for province
-- ----------------------------
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `province_id` varchar(255) DEFAULT NULL COMMENT '省份id',
  `province` varchar(255) DEFAULT NULL COMMENT '省份名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of province
-- ----------------------------
BEGIN;
INSERT INTO `province` (`id`, `province_id`, `province`) VALUES (1, '1', '河南省');
INSERT INTO `province` (`id`, `province_id`, `province`) VALUES (2, '2', '浙江省');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(16) DEFAULT NULL COMMENT '角色名字，职位',
  `role_code` int(2) NOT NULL COMMENT '角色代号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色表';

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `role_name`, `role_code`) VALUES (1, '超级管理员', 1);
INSERT INTO `role` (`id`, `role_name`, `role_code`) VALUES (2, '部门经理', 2);
INSERT INTO `role` (`id`, `role_name`, `role_code`) VALUES (3, '部门主管', 3);
INSERT INTO `role` (`id`, `role_name`, `role_code`) VALUES (4, 'admin', 4);
COMMIT;

-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `permission_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of role_permission
-- ----------------------------
BEGIN;
INSERT INTO `role_permission` (`id`, `role_id`, `permission_id`) VALUES (1, 1, 1);
INSERT INTO `role_permission` (`id`, `role_id`, `permission_id`) VALUES (2, 2, 1);
INSERT INTO `role_permission` (`id`, `role_id`, `permission_id`) VALUES (3, 4, 2);
INSERT INTO `role_permission` (`id`, `role_id`, `permission_id`) VALUES (4, 3, 1);
COMMIT;

-- ----------------------------
-- Table structure for role_user
-- ----------------------------
DROP TABLE IF EXISTS `role_user`;
CREATE TABLE `role_user` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `role_id` int(20) DEFAULT NULL,
  `user_id` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户角色关联表';

-- ----------------------------
-- Records of role_user
-- ----------------------------
BEGIN;
INSERT INTO `role_user` (`id`, `role_id`, `user_id`) VALUES (1, 3, 13);
INSERT INTO `role_user` (`id`, `role_id`, `user_id`) VALUES (3, 4, 1);
COMMIT;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` (`id`, `name`, `age`) VALUES (1, '小王', 13);
INSERT INTO `student` (`id`, `name`, `age`) VALUES (2, '小王', 13);
COMMIT;

-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of test
-- ----------------------------
BEGIN;
INSERT INTO `test` (`id`, `name`, `age`) VALUES (1, '小明', 15);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(30) DEFAULT NULL COMMENT '姓名',
  `password` varchar(10) DEFAULT NULL,
  `sex` int(11) DEFAULT NULL COMMENT '性别（0未知，1男，2女）',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(255) DEFAULT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `version` int(11) DEFAULT '0',
  `deleted` int(1) unsigned zerofill DEFAULT '0' COMMENT '0，未删除，1，已删除',
  `page_Picture` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (1, 'admin', '123456', NULL, 12, 'test1@baomidou.com', NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (2, '小花', NULL, NULL, 12, 'test2@baomidou.com', NULL, NULL, '2021-05-22 20:42:17.028000', NULL, 2, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (3, '西凉锦马超', NULL, NULL, 39, 'test3@baomidou.com', NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (4, 'ls', NULL, NULL, 22, 'test4@baomidou.com', NULL, NULL, '2021-05-22 14:47:40.444000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (5, 'Billie', NULL, NULL, 24, 'test5@baomidou.com', NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (6, 'ls', NULL, NULL, 26, '55317332@qq.com', NULL, NULL, '2021-05-20 17:05:15.561000', NULL, 6, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (7, 'libai', NULL, NULL, 18, '55317332@qq.com', NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (8, 'libai1', NULL, NULL, 18, '55317332@qq.com', NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (9, 'libai11', NULL, NULL, 181, '55317332@qq.com', NULL, '2021-05-18 10:23:55.711000', '2021-05-18 10:23:55.711000', NULL, 0, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (10, NULL, NULL, NULL, 18, '55317332@qq.com', NULL, '2021-05-18 15:02:48.049000', '2021-05-18 15:02:48.049000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (11, '宫本武藏33', NULL, NULL, 50, '121@qq.com', NULL, '2021-05-20 19:52:14.137000', '2021-05-22 19:38:29.389000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (12, '优雅恋人', NULL, NULL, 18, '111@qq.com', NULL, '2021-05-20 19:58:28.570000', '2021-05-20 19:58:28.570000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (13, '123456', '123456', 1, 123456, '1', 'WpsoLCyACJI0kzgBxOHAtA==', '2021-05-21 14:21:26.799000', '2021-05-21 14:21:26.799000', NULL, 1, 0, '11111111');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (14, '上官婉儿', NULL, NULL, 18, '1213639167@qq.com', NULL, '2021-05-22 19:18:04.318000', '2021-05-22 19:18:04.318000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (15, '不知火舞', NULL, NULL, 19, '121@buzhihuowu.com', NULL, '2021-05-22 19:20:12.231000', '2021-05-22 19:20:12.231000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (16, '娜可露露', NULL, NULL, 18, '121@lulu.com', NULL, '2021-05-22 19:21:17.103000', '2021-05-22 19:21:17.103000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (17, '鲁班大师', NULL, NULL, 55, '121@luban.com', NULL, '2021-05-22 19:22:20.060000', '2021-05-22 19:22:20.060000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (18, '亚瑟', NULL, NULL, 18, 'sdc@qq.com', NULL, '2021-05-24 16:48:54.011000', '2021-05-24 16:48:54.011000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (19, '关于', NULL, NULL, 40, 'sdc@qq.com', NULL, '2021-05-24 16:49:08.865000', '2021-05-24 16:49:08.865000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (20, '花木兰', NULL, NULL, 16, 'sdc@qq.com', NULL, '2021-05-24 16:49:27.338000', '2021-05-24 16:49:27.338000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (21, '干将莫邪', NULL, NULL, 20, 'sdc@qq.com', NULL, '2021-05-24 16:49:46.536000', '2021-05-24 16:49:46.536000', NULL, 1, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (22, '1111111111', '123456', 1, NULL, '121@qq.com', NULL, '2022-02-18 14:44:35.585000', NULL, NULL, NULL, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (23, '朱大地', '123456', 2, NULL, '121@qq.com', '13213018164', '2022-02-18 14:49:04.817000', NULL, NULL, NULL, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (24, '朱大地', '123456', 1, 23, 'ccccccc', '13213018164', '2022-02-18 14:55:02.988000', NULL, NULL, NULL, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (25, '达瓦里氏', NULL, NULL, 18, '55317332@qq.com', 'WpsoLCyACJI0kzgBxOHAtA==', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (26, '达瓦里氏', NULL, NULL, 18, '55317332@qq.com', 'WpsoLCyACJI0kzgBxOHAtA==', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (27, '达瓦里氏', NULL, NULL, 18, '55317332@qq.com', '13213018888', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (28, '达瓦里氏', NULL, NULL, 18, '55317332@qq.com', '13213018888', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (29, '达瓦里氏', NULL, NULL, 18, '55317332@qq.com', '13213018888', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (30, '小王', NULL, NULL, 18, '55317332@qq.com', '13213018888', NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (31, '1212', '121212', NULL, 12, '1212', '121', '2022-04-01 11:58:17.931000', NULL, NULL, 0, 0, '124');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (32, '1212', '121212', NULL, 12, '1212', '121', '2022-04-01 11:59:34.800000', NULL, NULL, 0, 0, '124');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (33, '1212', '121212', NULL, 12, '1212', '121', '2022-04-01 12:01:01.106000', NULL, NULL, 0, 0, '124');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (34, '1212', '121212', NULL, 12, '1212', '6XJ670mPWag=', '2022-04-01 14:37:32.523000', NULL, NULL, 0, 0, '124');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (35, '桑启', NULL, NULL, 15, '12@qq.com', NULL, NULL, NULL, NULL, NULL, 0, '');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (36, '', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, 0, '');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (37, '22', NULL, NULL, 22, '', NULL, NULL, NULL, NULL, NULL, 0, '');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (38, '马可', NULL, NULL, 6, '55', NULL, NULL, NULL, NULL, NULL, 0, 'https://zhudadi.oss-cn-beijing.aliyuncs.com/2022-04-29/c3b616e9-f4b7-460e-81d8-ec29541da2f0_5.jpg');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (39, '黄忠', NULL, NULL, 66, '66', NULL, NULL, NULL, NULL, NULL, 0, 'https://zhudadi.oss-cn-beijing.aliyuncs.com/2022-04-29/8352ef33-844a-42b7-890d-457cd828a93e_2.jpg');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (40, '245', NULL, NULL, 25, '25', NULL, NULL, NULL, NULL, NULL, 1, 'https://zhudadi.oss-cn-beijing.aliyuncs.com/2022-04-29/8f61e25d-f266-4f9e-84f1-a0f246856a86_50336.jpg');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (41, '境', NULL, NULL, 33, '11', NULL, NULL, NULL, NULL, NULL, NULL, 'https://zhudadi.oss-cn-beijing.aliyuncs.com/2022-04-29/68fadb16-b908-434c-819a-4df8e42656f0_2.jpg');
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (42, '??', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (43, '??', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (44, '??', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` (`id`, `name`, `password`, `sex`, `age`, `email`, `phone`, `create_time`, `update_time`, `last_login_time`, `version`, `deleted`, `page_Picture`) VALUES (45, '??', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for v_hdcallspecail
-- ----------------------------
DROP TABLE IF EXISTS `v_hdcallspecail`;
CREATE TABLE `v_hdcallspecail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `HardWareID` int(11) DEFAULT NULL COMMENT '呼叫器地址',
  `RoomNo` varchar(255) DEFAULT NULL COMMENT '窗口号',
  `GroupNO` varchar(255) DEFAULT NULL COMMENT '队列号',
  `GroupName` varchar(255) DEFAULT NULL COMMENT '队列名称',
  `Specail` varchar(255) DEFAULT NULL COMMENT '顺序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of v_hdcallspecail
-- ----------------------------
BEGIN;
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (1, 1, '01', '1', '查询业务', '6');
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (2, 1, '2', '3', '4', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (3, 1, '1', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (4, 2, '2', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (5, 3, '3', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (6, 4, '4', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (7, 5, '5', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (8, 6, '6', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (9, 7, '7', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (10, 8, '8', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (11, 9, '9', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (12, 10, '10', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (13, 11, '11', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (14, 12, '12', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (15, 13, '13', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (16, 14, '14', '3', '二手房交易', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (17, 15, '15', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (18, 16, '16', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (19, 17, '17', '5', '查询', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (20, 18, '18', '3', '二手房交易', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (21, 19, '19', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (22, 20, '20', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (23, 21, '21', '2', '领证', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (24, 22, '22', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (25, 23, '23', '0', '预留', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (26, 28, 'NULL', '20', 'NULL', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (27, 31, 'NULL', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (28, 36, 'NULL', '1', '登记受理', NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (29, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (30, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (31, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (32, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (33, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (34, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (35, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (36, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (37, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (38, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (39, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (40, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (41, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (42, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (43, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (44, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (45, 0, NULL, NULL, NULL, NULL);
INSERT INTO `v_hdcallspecail` (`id`, `HardWareID`, `RoomNo`, `GroupNO`, `GroupName`, `Specail`) VALUES (46, 0, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for v_jhmx
-- ----------------------------
DROP TABLE IF EXISTS `v_jhmx`;
CREATE TABLE `v_jhmx` (
  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一识别号',
  `SerialID` int(11) DEFAULT NULL COMMENT '在某队列中当前序号，0为已呼叫',
  `CureGroupNo` int(11) DEFAULT NULL COMMENT '队列编号',
  `CustName` varchar(255) DEFAULT NULL COMMENT '姓名',
  `groupname` varchar(255) DEFAULT NULL COMMENT '队列名称',
  `Qno` varchar(255) DEFAULT NULL COMMENT '排队序号',
  `RegDateTime` datetime DEFAULT NULL COMMENT '取号日期',
  `CureDateTime` datetime DEFAULT NULL COMMENT '服务时间（即呼叫的时间）',
  `Status` varchar(255) DEFAULT NULL COMMENT '状态，1等候中 0 已呼叫',
  `UserID` varchar(255) DEFAULT NULL COMMENT '员工号（呼叫的员工）',
  `Roomno` int(11) DEFAULT NULL COMMENT '窗口号',
  `AppQStatus` int(11) DEFAULT NULL COMMENT '时间段, 上下午标志0全天  1上午 2下午',
  `Departmentname` varchar(255) DEFAULT NULL COMMENT '部门名称',
  `DepartmentID` varchar(255) DEFAULT NULL COMMENT '部门编号',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=117828 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of v_jhmx
-- ----------------------------
BEGIN;
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117689, 0, 1, NULL, '登记受理', '1001', '2022-02-22 07:43:15', '2022-03-01 11:35:21', '0', '5', 5, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117690, 0, 1, NULL, '登记受理', '1002', '2022-02-22 07:43:21', '2022-03-01 11:35:24', '0', '13', 13, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117691, 0, 1, NULL, '登记受理', '1003', '2022-02-22 07:43:25', '2022-03-01 11:35:26', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117692, 0, 1, NULL, '登记受理', '1004', '2022-02-22 07:43:29', '2022-03-01 11:35:29', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117693, 0, 1, NULL, '登记受理', '1005', '2022-02-22 07:43:33', '2022-03-01 11:35:31', '0', '3', 3, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117694, 0, 1, NULL, '登记受理', '1006', '2022-02-22 07:43:35', '2022-03-01 11:35:34', '0', '11', 11, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117695, 0, 1, NULL, '登记受理', '1007', '2022-02-22 07:43:38', '2022-03-01 11:34:36', '0', '1', 1, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117696, 0, 1, NULL, '登记受理', '1008', '2022-02-22 07:43:41', '2022-03-01 11:36:38', '0', '9', 9, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117697, 0, 1, NULL, '登记受理', '1009', '2022-02-22 07:43:44', '2022-02-25 15:35:12', '0', '5', 5, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117698, 0, 1, NULL, '登记受理', '1010', '2022-02-22 07:43:46', '2022-02-25 15:35:12', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117699, 0, 1, NULL, '登记受理', '1011', '2022-02-22 07:43:49', '2022-02-25 15:35:12', '0', '2', 2, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117700, 0, 1, NULL, '登记受理', '1012', '2022-02-22 07:43:53', '2022-02-25 15:35:12', '0', '11', 11, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117701, 0, 1, NULL, '登记受理', '1013', '2022-02-22 07:43:55', '2022-02-25 15:35:12', '0', '11', 11, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117702, 0, 1, NULL, '登记受理', '1014', '2022-02-22 07:43:57', '2022-02-25 15:35:12', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117703, 0, 1, NULL, '登记受理', '1015', '2022-02-22 07:43:59', '2022-02-25 15:35:12', '0', '9', 9, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117704, 0, 1, NULL, '登记受理', '1016', '2022-02-22 07:44:03', '2022-02-25 15:35:12', '0', '1', 1, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117705, 0, 1, NULL, '登记受理', '1017', '2022-02-22 07:44:05', '2022-02-25 15:35:12', '0', '9', 9, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117706, 0, 1, NULL, '登记受理', '1018', '2022-02-22 07:44:09', '2022-02-25 15:35:12', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117707, 0, 1, NULL, '登记受理', '1019', '2022-02-22 07:44:20', '2022-02-25 15:35:12', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117708, 0, 1, NULL, '登记受理', '1020', '2022-02-22 07:44:23', '2022-02-25 15:35:12', '0', '5', 5, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117709, 0, 1, NULL, '登记受理', '1021', '2022-02-22 07:44:25', '2022-02-25 15:35:12', '0', '2', 2, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117710, 0, 1, NULL, '登记受理', '1022', '2022-03-02 10:01:45', '2022-03-02 10:01:10', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117711, 0, 1, NULL, '登记受理', '1023', '2022-02-22 07:44:30', '2022-02-25 15:35:12', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117712, 0, 1, NULL, '登记受理', '1024', '2022-02-22 07:44:32', '2022-02-25 15:35:12', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117713, 0, 1, NULL, '登记受理', '1025', '2022-02-22 07:44:34', '2022-02-25 15:35:12', '0', '1', 1, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117714, 0, 1, NULL, '登记受理', '1026', '2022-02-22 07:44:36', '2022-02-25 15:35:12', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117715, 0, 1, NULL, '登记受理', '1027', '2022-02-22 07:44:40', '2022-03-02 10:38:22', '0', '11', 11, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117716, 0, 1, NULL, '登记受理', '1028', '2022-02-22 07:44:42', '2022-03-02 10:40:01', '0', '13', 13, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117717, 0, 1, NULL, '登记受理', '1029', '2022-02-22 07:44:44', '2022-03-02 10:45:42', '0', '5', 5, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117718, 0, 1, NULL, '登记受理', '1030', '2022-02-22 07:44:46', '2022-02-25 15:35:12', '0', '11', 11, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117719, 0, 1, NULL, '登记受理', '1031', '2022-02-22 07:44:52', '2022-02-25 15:35:12', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117720, 0, 1, NULL, '登记受理', '1032', '2022-02-22 07:44:55', '2022-02-25 15:35:12', '0', '9', 9, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117721, 0, 1, NULL, '登记受理', '1033', '2022-02-22 07:44:57', '2022-02-25 15:35:12', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117722, 0, 1, NULL, '登记受理', '1034', '2022-02-22 07:44:59', '2022-02-25 15:35:12', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117723, 0, 1, NULL, '登记受理', '1035', '2022-02-22 07:46:02', '2022-02-25 15:35:12', '0', '9', 9, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117724, 0, 1, NULL, '登记受理', '1036', '2022-02-22 07:46:05', '2022-02-25 15:35:12', '0', '9', 9, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117725, 0, 1, NULL, '登记受理', '1037', '2022-02-22 07:46:07', '2022-02-25 15:35:12', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117726, 0, 1, NULL, '登记受理', '1038', '2022-02-22 07:46:10', '2022-02-28 13:42:41', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117727, 0, 1, NULL, '登记受理', '1039', '2022-02-22 07:46:13', '2022-02-28 13:42:44', '0', '5', 5, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117728, 0, 1, NULL, '登记受理', '1040', '2022-02-22 07:46:15', '2022-02-28 13:42:46', '0', '13', 13, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117729, 0, 1, NULL, '登记受理', '1041', '2022-02-22 07:46:17', '2022-02-25 15:35:12', '0', '3', 3, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117730, 0, 1, NULL, '登记受理', '1042', '2022-02-22 07:46:20', '2022-02-25 15:35:12', '0', '13', 13, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117731, 0, 1, NULL, '登记受理', '1043', '2022-02-22 07:46:22', '2022-02-25 15:35:12', '0', '13', 13, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117732, 0, 1, NULL, '登记受理', '1044', '2022-02-22 07:46:24', '2022-03-02 11:45:12', '0', '3', 3, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117733, 0, 1, NULL, '登记受理', '1045', '2022-02-22 07:46:26', '2022-02-25 15:35:12', '0', '5', 5, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117734, 0, 1, NULL, '登记受理', '1046', '2022-02-22 07:46:31', '2022-03-02 10:30:21', '0', '5', 5, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117735, 0, 1, NULL, '登记受理', '1047', '2022-02-22 07:46:35', '2022-03-02 10:25:28', '0', '5', 5, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117736, 0, 1, NULL, '登记受理', '1048', '2022-02-22 07:46:38', '2022-03-02 10:14:57', '0', '1', 1, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117737, 0, 1, NULL, '登记受理', '1049', '2022-02-22 07:46:43', '2022-03-02 10:34:55', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117738, 0, 1, NULL, '登记受理', '1050', '2022-02-22 07:46:46', '2022-03-02 09:23:10', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117739, 0, 1, NULL, '登记受理', '1051', '2022-02-22 07:46:49', '2022-03-02 09:26:22', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117740, 0, 1, NULL, '登记受理', '1052', '2022-02-22 07:46:51', '2022-03-02 10:29:59', '0', '3', 3, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117741, 0, 1, NULL, '登记受理', '1053', '2022-02-22 07:46:53', '2022-03-02 09:44:27', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117742, 0, 1, NULL, '登记受理', '1054', '2022-02-22 07:46:57', '2022-03-02 09:44:29', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117743, 0, 1, NULL, '登记受理', '1055', '2022-02-22 07:47:00', '2022-03-02 09:44:32', '0', '11', 11, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117744, 0, 1, NULL, '登记受理', '1056', '2022-02-22 07:47:04', '2022-03-02 09:44:35', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117745, 0, 1, NULL, '登记受理', '1057', '2022-02-22 07:47:06', '2022-03-02 09:44:37', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117746, 0, 1, NULL, '登记受理', '1058', '2022-02-22 07:47:10', '2022-03-02 10:33:45', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117747, 0, 1, NULL, '登记受理', '1059', '2022-02-22 07:47:12', '2022-03-01 11:00:55', '0', '13', 13, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117748, 0, 1, NULL, '登记受理', '1060', '2022-02-22 07:47:15', '2022-03-01 11:00:52', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117749, 0, 3, NULL, '二手房交易', '3001', '2022-02-22 07:47:17', '2022-03-02 09:04:44', '0', '14', 14, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117750, 0, 3, NULL, '二手房交易', '3002', '2022-02-22 07:47:19', '2022-03-02 10:15:22', '0', '14', 14, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117751, 0, 3, NULL, '二手房交易', '3003', '2022-02-22 07:47:21', '2022-03-01 10:59:49', '0', '14', 14, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117752, 0, 3, NULL, '二手房交易', '3004', '2022-02-22 07:47:24', '2022-03-01 10:59:52', '0', '14', 14, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117753, 0, 3, NULL, '二手房交易', '3005', '2022-02-22 07:47:27', '2022-03-01 10:59:56', '0', '14', 14, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117754, 0, 3, NULL, '二手房交易', '3006', '2022-02-22 09:16:23', '2022-03-01 11:00:00', '0', '14', 14, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117755, 0, 3, NULL, '二手房交易', '3007', '2022-02-22 09:16:31', '2022-03-01 11:50:04', '0', '14', 14, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117756, 0, 3, NULL, '二手房交易', '3008', '2022-02-22 09:16:33', '2022-03-01 11:00:09', '0', '14', 14, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117757, 0, 1, NULL, '登记受理', '1061', '2022-02-22 10:46:00', '2022-03-01 11:01:33', '0', '5', 5, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117758, 0, 1, NULL, '登记受理', '1062', '2022-02-22 10:46:03', '2022-03-01 11:00:36', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117759, 0, 1, NULL, '登记受理', '1063', '2022-02-22 10:46:06', '2022-03-01 11:00:38', '0', '8', 8, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117760, 0, 1, NULL, '登记受理', '1064', '2022-02-22 10:46:10', '2022-03-01 11:00:41', '0', '13', 13, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117761, 0, 1, NULL, '登记受理', '1065', '2022-02-22 10:46:13', '2022-03-01 11:00:44', '0', '7', 7, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117762, 0, 1, NULL, '登记受理', '1066', '2022-02-22 10:46:16', '2022-03-01 11:00:47', '0', '13', 13, 1, '本单位', '1');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117763, 1, 1, NULL, '登记受理', '1067', '2022-02-22 13:40:11', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117764, 2, 1, NULL, '登记受理', '1068', '2022-02-22 13:40:14', '2022-03-01 18:11:39', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117765, 3, 1, NULL, '登记受理', '1069', '2022-02-22 13:40:22', '2022-03-02 09:03:23', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117766, 4, 1, NULL, '登记受理', '1070', '2022-02-22 13:40:26', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117767, 5, 1, NULL, '登记受理', '1071', '2022-02-22 13:40:30', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117768, 6, 1, NULL, '登记受理', '1072', '2022-02-22 13:40:34', '2022-03-01 18:11:43', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117769, 7, 1, NULL, '登记受理', '1073', '2022-02-22 13:40:37', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117770, 8, 1, NULL, '登记受理', '1074', '2022-02-22 13:40:40', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117771, 9, 1, NULL, '登记受理', '1075', '2022-02-22 13:40:44', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117772, 10, 1, NULL, '登记受理', '1076', '2022-02-22 13:40:47', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117773, 11, 1, NULL, '登记受理', '1077', '2022-02-22 13:40:50', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117774, 12, 1, NULL, '登记受理', '1078', '2022-02-22 13:40:53', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117775, 13, 1, NULL, '登记受理', '1079', '2022-02-22 13:40:56', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117776, 14, 1, NULL, '登记受理', '1080', '2022-02-22 13:40:59', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117777, 15, 1, NULL, '登记受理', '1081', '2022-02-22 13:41:02', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117778, 16, 1, NULL, '登记受理', '1082', '2022-02-22 13:41:06', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117779, 17, 1, NULL, '登记受理', '1083', '2022-02-22 13:41:09', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117780, 18, 1, NULL, '登记受理', '1084', '2022-02-22 13:41:12', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117781, 19, 1, NULL, '登记受理', '1085', '2022-02-22 13:41:15', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117782, 20, 1, NULL, '登记受理', '1086', '2022-02-22 13:41:19', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117783, 21, 1, NULL, '登记受理', '1087', '2022-02-22 13:41:22', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117784, 22, 1, NULL, '登记受理', '1088', '2022-02-22 13:41:25', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117785, 23, 1, NULL, '登记受理', '1089', '2022-02-22 13:41:29', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117786, 24, 1, NULL, '登记受理', '1090', '2022-02-22 13:41:32', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117787, 25, 1, NULL, '登记受理', '1091', '2022-02-22 13:41:36', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117788, 26, 1, NULL, '登记受理', '1092', '2022-02-22 13:41:40', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117789, 27, 1, NULL, '登记受理', '1093', '2022-02-22 13:41:45', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117790, 28, 1, NULL, '登记受理', '1094', '2022-02-22 13:41:49', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117791, 29, 1, NULL, '登记受理', '1095', '2022-02-22 13:41:53', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117792, 30, 1, NULL, '登记受理', '1096', '2022-02-22 13:41:57', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117793, 31, 1, NULL, '登记受理', '1097', '2022-02-22 13:42:12', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117794, 32, 1, NULL, '登记受理', '1098', '2022-02-22 13:42:15', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117795, 33, 1, NULL, '登记受理', '1099', '2022-02-22 13:42:21', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117796, 34, 1, NULL, '登记受理', '1100', '2022-02-22 13:42:24', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117797, 35, 1, NULL, '登记受理', '1101', '2022-02-22 13:42:28', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117798, 36, 1, NULL, '登记受理', '1102', '2022-02-22 13:42:31', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117799, 37, 1, NULL, '登记受理', '1103', '2022-02-22 13:42:35', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117800, 38, 1, NULL, '登记受理', '1104', '2022-02-22 13:42:38', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117801, 39, 1, NULL, '登记受理', '1105', '2022-02-22 13:42:42', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117802, 40, 1, NULL, '登记受理', '1106', '2022-02-22 13:42:45', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117803, 41, 1, NULL, '登记受理', '1107', '2022-02-22 13:42:48', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117804, 42, 1, NULL, '登记受理', '1108', '2022-02-22 13:42:51', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117805, 43, 1, NULL, '登记受理', '1109', '2022-02-22 13:42:55', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117806, 44, 1, NULL, '登记受理', '1110', '2022-02-22 13:42:58', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117807, 45, 1, NULL, '登记受理', '1111', '2022-02-22 13:43:02', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117808, 46, 1, NULL, '登记受理', '1112', '2022-02-22 13:43:05', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117809, 47, 1, NULL, '登记受理', '1113', '2022-02-22 13:43:08', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117810, 48, 1, NULL, '登记受理', '1114', '2022-02-22 13:43:12', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117811, 49, 1, NULL, '登记受理', '1115', '2022-02-22 13:43:18', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117812, 50, 1, NULL, '登记受理', '1116', '2022-02-22 13:43:22', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117813, 51, 1, NULL, '登记受理', '1117', '2022-02-22 13:43:25', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117814, 52, 1, NULL, '登记受理', '1118', '2022-02-22 13:43:29', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117815, 53, 1, NULL, '登记受理', '1119', '2022-02-22 13:43:32', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117816, 54, 1, NULL, '登记受理', '1120', '2022-02-22 13:43:35', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117817, 55, 1, NULL, '登记受理', '1121', '2022-02-22 13:43:39', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117818, 56, 1, NULL, '登记受理', '1122', '2022-02-22 13:43:42', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117819, 57, 1, NULL, '登记受理', '1123', '2022-02-22 13:43:46', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117820, 58, 1, NULL, '登记受理', '1124', '2022-02-22 13:43:50', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117821, 59, 1, NULL, '登记受理', '1125', '2022-02-22 13:43:53', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117822, 60, 1, NULL, '登记受理', '1126', '2022-02-22 13:43:57', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117823, 1, 3, NULL, '二手房交易', '3009', '2022-02-22 13:44:02', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117824, 2, 3, NULL, '二手房交易', '3010', '2022-02-22 13:44:08', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117825, 3, 3, NULL, '二手房交易', '3011', '2022-02-22 13:44:11', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117826, 4, 3, NULL, '二手房交易', '3012', '2022-02-22 13:44:16', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
INSERT INTO `v_jhmx` (`ID`, `SerialID`, `CureGroupNo`, `CustName`, `groupname`, `Qno`, `RegDateTime`, `CureDateTime`, `Status`, `UserID`, `Roomno`, `AppQStatus`, `Departmentname`, `DepartmentID`) VALUES (117827, 5, 3, NULL, '二手房交易', '3013', '2022-02-22 13:44:19', '2022-02-25 15:35:12', '1', 'NULL', NULL, 1, 'NULL', 'NULL');
COMMIT;

-- ----------------------------
-- View structure for test_view
-- ----------------------------
DROP VIEW IF EXISTS `test_view`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `test_view` AS select `user`.`name` AS `name`,`user`.`age` AS `age`,`user`.`email` AS `email` from `user` where (`user`.`id` in (1,2,3,4,5,6,7,8));

SET FOREIGN_KEY_CHECKS = 1;
